package com.user.mapper;

import com.user.pojo.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.user.pojo.data;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Administrator
* @description 针对表【user(用户表)】的数据库操作Mapper
* @createDate 2024-09-20 10:20:16
* @Entity com.user.pojo.User
*/
public interface UserMapper extends BaseMapper<User> {

    @Select("SELECT * " + "FROM user " + "LEFT JOIN position ON  COALESCE(user.position_id) = COALESCE(position.id) " )
    List<data>  selectUserData();


}





